UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUs06NjVFK+VLftWWOae5QQIs8sabZgYzqnhls409pQ='
WHERE
key_id = 'f400750385769159ec57d31fca7bb0a4a8ee713a7ef79eede510d26bb53abc1a'
AND (
token = 'zUs06NjVFK+VLftWWOae5QQIs8sabZgYzqnhls409pQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)