UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXZmWQaQK72q/HI71pM1zbwdFGcs5JmW7KU5D5O2H80='
WHERE
key_id = '7f5959587342aa8d7393cdbddc39c7ef32c4cc325b668da3b8acdf4d057c6197'
AND (
token = 'NXZmWQaQK72q/HI71pM1zbwdFGcs5JmW7KU5D5O2H80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)