UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G47uMhF03aop0lkfe7h7WJ5EiAVeC1OEPMAl/c1uDlc='
WHERE
key_id = '5b274cdbbc5b573b5d5396e941afd89f1dbde0ac0c1c699208f97afda0ba0f10'
AND (
token = 'G47uMhF03aop0lkfe7h7WJ5EiAVeC1OEPMAl/c1uDlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)