UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zY7vtlEOxqxduSfSjb+MXBtQ7251K3OhGrjd13NrVTg='
WHERE
key_id = 'd0475281a7007caf706258ac9d8fda23b7de31f89c7798545e436a9484042758'
AND (
token = 'zY7vtlEOxqxduSfSjb+MXBtQ7251K3OhGrjd13NrVTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)