UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SqqYxjaUVdxRXFjIhB1m1qOrqmiAtw+i4R3sA4UDrh8='
WHERE
key_id = 'c2eea27b1acc90d2c7ecd649a178f0fa8f0627f965a9e38809ab8fbe20cf191c'
AND (
token = 'SqqYxjaUVdxRXFjIhB1m1qOrqmiAtw+i4R3sA4UDrh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)