UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wR/oc04HUQa+MBFxximG+t8nibvM52+a+9qwZFvN5zY='
WHERE
key_id = '48c1e16e4652a768bab881e6342b3f31640961169d8c918987a3a3fb3ef73ceb'
AND (
token = 'wR/oc04HUQa+MBFxximG+t8nibvM52+a+9qwZFvN5zY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)