UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjZGtgmt4wvS6ohKlyf13YfckdexwJrJVEx/NMXIawo='
WHERE
key_id = '3087ee7e84992489f24d5a6eb9714a9f205589b4bcaeca4253647d5455cc06ae'
AND (
token = 'ZjZGtgmt4wvS6ohKlyf13YfckdexwJrJVEx/NMXIawo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)