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