UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Gi9w2Fs94vSIlO9RzQstdCwIBsZmzvFO/L4iBygxfY='
WHERE
key_id = 'c16322cf5626484923515e1fb75bedf86b807fb796208ab4b6d427e287b29dae'
AND (
token = '3Gi9w2Fs94vSIlO9RzQstdCwIBsZmzvFO/L4iBygxfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)