UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qG1qmXZe5f5DCZ4wLALxZizEIxvMSEB2Dml3bORqCrw='
WHERE
key_id = '78e98143cb5082b9acb31f325bd0103ab16eca56befdfaaa92965b8fc9fcf033'
AND (
token = 'qG1qmXZe5f5DCZ4wLALxZizEIxvMSEB2Dml3bORqCrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)