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