UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnjzxfkL3RqmW5iEKudTd2HaPYdC7KVDztx8s/yFfpw='
WHERE
key_id = 'dc96aa38a3559460ddf3d72d4bce7863d40732816ac3ac87cdc840e1a371faa4'
AND (
token = 'nnjzxfkL3RqmW5iEKudTd2HaPYdC7KVDztx8s/yFfpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)