UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5iuJ6gUq9AJrlQm6R3XUVp0zGvGVuJN7XyJcghMMA0='
WHERE
key_id = '1e55dfb649fc913068f13228797acdf2978eb86c7c78e9c624200549479885cd'
AND (
token = 'D5iuJ6gUq9AJrlQm6R3XUVp0zGvGVuJN7XyJcghMMA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)