UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/gnAqRvkGpp64XmcacbJUihJTDdg7M7ChBL0azStdJw='
WHERE
key_id = 'f6c593dffbe1591a3dc46a1e72dae0d6d43945aebb2d519b7384246c2ba640ac'
AND (
token = '/gnAqRvkGpp64XmcacbJUihJTDdg7M7ChBL0azStdJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)