UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RDH6RS8cXz3C+Lc//G8pgqUzoK2lyOVmsiE4Wqg9brE='
WHERE
key_id = 'd3ca19561e3864dbd3cbed381a4cb238b9c18251045243265543c0faac91b170'
AND (
token = 'RDH6RS8cXz3C+Lc//G8pgqUzoK2lyOVmsiE4Wqg9brE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)