UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MpO6pkFwW8QBkjQfjCKB/U8M6yorcqcCIR65ZQjWVwM='
WHERE
key_id = '3692bf672e9afad0fe793ed89f4076fa41331e379c55472276722583d4f74840'
AND (
token = 'MpO6pkFwW8QBkjQfjCKB/U8M6yorcqcCIR65ZQjWVwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)