UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLgcmoNewLNZoj4GGh12UHgfwyCFFgjnpUBQu91mbCk='
WHERE
key_id = 'e2c04383f61dac56c68d3bf2fef6e0a4f0ab6c42882dcbc92466e2a420ea1491'
AND (
token = 'hLgcmoNewLNZoj4GGh12UHgfwyCFFgjnpUBQu91mbCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)