UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEXNfkoqy+kfiwVN78HwCLf3FdX0nCgAly9lvFmxFGc='
WHERE
key_id = '5a07454db9879cd615d54bd2ebf28b24439bc2203ad8b5ee3486ffe80169c167'
AND (
token = 'gEXNfkoqy+kfiwVN78HwCLf3FdX0nCgAly9lvFmxFGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)