UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPFjB/zc5uBumEGQ/PPZSm2b7gEaSiAPIHJYVwbYllg='
WHERE
key_id = '3bae2172d9a8eac252b64e039af6c0e66e0e334f0d2de15957a06d6ec9f1389a'
AND (
token = 'BPFjB/zc5uBumEGQ/PPZSm2b7gEaSiAPIHJYVwbYllg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)