UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WkXJzdnkCBDcOJmYcmso1sD6N37efVTcWJWB/0sr8kA='
WHERE
key_id = 'e6a9f2671df89f12ed6e389724a4264df8569287b44024c03cf936d668e08e4c'
AND (
token = 'WkXJzdnkCBDcOJmYcmso1sD6N37efVTcWJWB/0sr8kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)