UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCrKVjVofWKzgDCqe8AuyaD6FZ7YxlPrq1prJP3I7YI='
WHERE
key_id = '474ebd7f63239657a1797da1286710da9962b0e54b324347ce268c3a69f5548e'
AND (
token = 'VCrKVjVofWKzgDCqe8AuyaD6FZ7YxlPrq1prJP3I7YI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)