UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hT3dgCQPDdy7i1gIgXNT6ZuDybsUw323hGwASlh3fxw='
WHERE
key_id = 'fd6253521b16953631291653d70debbea556bda108a6deb7739df506b20077b6'
AND (
token = 'hT3dgCQPDdy7i1gIgXNT6ZuDybsUw323hGwASlh3fxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)