UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h1wJPnUeI25vBU/KkcT4JdyMtoILDo7Yspv/yLlZwsc='
WHERE
key_id = '1a479de328d148ed335f6f8da7f2e0e1e23d4fe87d8b4036d7d18a76ece01286'
AND (
token = 'h1wJPnUeI25vBU/KkcT4JdyMtoILDo7Yspv/yLlZwsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)