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