UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9K/b5k+jvpgMnhbUgIKyIdIeCxpeLVks/o6/R9g794='
WHERE
key_id = '16b6d5e85184d74aa5f029259abb4a1404875a0b88be96c8b4141d77be3f54ad'
AND (
token = 'k9K/b5k+jvpgMnhbUgIKyIdIeCxpeLVks/o6/R9g794='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)