UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpHW+EFlAXwiWc9uXXf24zIDs7CV6Mxd/nqBf73Kjcw='
WHERE
key_id = '03349c576c15cd54a2c1e87384835d16780909365a49e473a630ae12016c87a5'
AND (
token = 'XpHW+EFlAXwiWc9uXXf24zIDs7CV6Mxd/nqBf73Kjcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)