UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnF6P1k1LDrGEGSzaTP7pVOW5wXGYrEAyiAY/qIp0Dw='
WHERE
key_id = 'c7babb664b53d5b96ce7c14c8a3a89a85bbfec2d6c728aa6d4d6e193e60fca10'
AND (
token = 'HnF6P1k1LDrGEGSzaTP7pVOW5wXGYrEAyiAY/qIp0Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)