UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jb2L2FjngTD5MZDo8WaePWoh2lXeVwd4dglwridCMvg='
WHERE
key_id = 'f8731bae8f4de109981d321968d920bc0eef1e90336b9c53c797a9b361ff57a8'
AND (
token = 'Jb2L2FjngTD5MZDo8WaePWoh2lXeVwd4dglwridCMvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)