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