UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ip1B5YrBxNkhIddX6pPbPEXCmhFnDdvRtoT+wlMpGxg='
WHERE
key_id = '40a727914297c8f1387d7778d0c7489cb572ce90fe55d975d0e773547b514046'
AND (
token = 'Ip1B5YrBxNkhIddX6pPbPEXCmhFnDdvRtoT+wlMpGxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)