UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9eDIY0s/sSDxn1GPSgw/uY5wAWfH74mQNDWqac9IjtU='
WHERE
key_id = 'c24399857503172a87bdb61c9b0f21fe183fd7c7ee049d5f3adf1b4cde8cc830'
AND (
token = '9eDIY0s/sSDxn1GPSgw/uY5wAWfH74mQNDWqac9IjtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)