UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vHcHhSB3GqW3/NziZ4YBpHJH9NfYvbj2FHzPoJwLco4='
WHERE
key_id = '84c1388c8a618ab72dda563c78c49a5ced831563de3b4d03684dace17e48274a'
AND (
token = 'vHcHhSB3GqW3/NziZ4YBpHJH9NfYvbj2FHzPoJwLco4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)