UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zjyyfNXlNoUk2agoTxoShBmqgkndLcurycFqusPKUU='
WHERE
key_id = '1256b09d365c423254c530592b58fdbd5eb180fb1e4a134bf57a9365fdb55dde'
AND (
token = '4zjyyfNXlNoUk2agoTxoShBmqgkndLcurycFqusPKUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)