UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I7ZBZRp2aXROlmm8vfu0Ao2gvy3RJKG42bG25mvlpcc='
WHERE
key_id = '7e50c20005c9ac1754e96688c7a4968adeb7bdc1617f97ea570ed04db877b6ea'
AND (
token = 'I7ZBZRp2aXROlmm8vfu0Ao2gvy3RJKG42bG25mvlpcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)